SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 41453: You cannot generate the data and control files for bulk loading to Oracle without automatically executing the SQL*Loader utility

DetailsAboutRate It

You cannot generate the data and control files that are required for bulk loading to Oracle without automatically executing the SQL*Loader utility. The bulk-loading facility in SAS/ACCESS® Interface to Oracle automatically generates these files and then uses them to execute the SQL*Loader utility.

You might need to modify the generated files prior to loading them into Oracle. For example, consider the issue of not having the ability to remove trailing blanks easily from variable-length variables when you bulk load data to Oracle. (See SAS Note 41451: "Trailing blanks appear at the end of a variable when you bulk load data to Oracle.")



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to OracleMicrosoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows XP Professional9.1 TS1M3 SP4
Windows Vista9.1 TS1M3 SP4
Windows Vista for x649.1 TS1M3 SP4
64-bit Enabled AIX9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled HP-UX9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled Solaris9.1 TS1M3 SP49.4 TS1M0
HP-UX IPF9.1 TS1M3 SP49.4 TS1M0
Linux9.1 TS1M3 SP49.4 TS1M0
Linux on Itanium9.1 TS1M3 SP49.4 TS1M0
OpenVMS Alpha9.1 TS1M3 SP49.4 TS1M0
Solaris for x649.1 TS1M3 SP49.4 TS1M0
Tru64 UNIX9.1 TS1M3 SP49.4 TS1M0
Microsoft® Windows® for x649.2 TS2M39.4 TS1M0
Microsoft Windows Server 2003 for x649.2 TS2M3
Microsoft Windows Server 20089.2 TS2M3
Microsoft Windows Server 2008 for x649.2 TS2M39.4 TS1M0
Windows 7 Enterprise 32 bit9.2 TS2M3
Windows 7 Enterprise x649.2 TS2M39.4 TS1M0
Windows 7 Home Premium 32 bit9.2 TS2M3
Windows 7 Home Premium x649.2 TS2M3
Windows 7 Professional 32 bit9.2 TS2M3
Windows 7 Professional x649.2 TS2M39.4 TS1M0
Windows 7 Ultimate 32 bit9.2 TS2M3
Windows 7 Ultimate x649.2 TS2M3
Linux for x649.2 TS2M39.4 TS1M0
OpenVMS on HP Integrity9.2 TS2M39.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.